object fmUnpayedBillsReport: TfmUnpayedBillsReport
  Left = 325
  Top = 201
  Width = 730
  Height = 658
  Caption = #1053#1077#1086#1087#1083#1072#1095#1077#1085#1085#1099#1077' '#1089#1095#1077#1090#1072
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  Menu = MainMenu1
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object frxPreview1: TfrxPreview
    Left = 0
    Top = 0
    Width = 722
    Height = 604
    Align = alClient
    OutlineVisible = False
    OutlineWidth = 120
    ThumbnailVisible = False
    UseReportHints = True
  end
  object frxReport1: TfrxReport
    Version = '4.11.7'
    DotMatrixReport = False
    IniFile = '\Software\Fast Reports'
    Preview = frxPreview1
    PreviewOptions.AllowEdit = False
    PreviewOptions.Buttons = [pbPrint, pbLoad, pbSave, pbExport, pbZoom, pbFind, pbOutline, pbPageSetup, pbTools, pbEdit, pbNavigator, pbExportQuick]
    PreviewOptions.Zoom = 1.000000000000000000
    PrintOptions.Printer = 'Default'
    PrintOptions.PrintOnSheet = 0
    ReportOptions.CreateDate = 40686.885931446800000000
    ReportOptions.LastChange = 40686.928417523100000000
    ScriptLanguage = 'PascalScript'
    ScriptText.Strings = (
      'begin'
      ''
      'end.')
    Top = 64
    Datasets = <
      item
        DataSet = frxDBDataset1
        DataSetName = 'frxDBDataset1'
      end>
    Variables = <>
    Style = <>
    object Data: TfrxDataPage
      Height = 1000.000000000000000000
      Width = 1000.000000000000000000
    end
    object Page1: TfrxReportPage
      PaperWidth = 215.900000000000000000
      PaperHeight = 279.400000000000000000
      PaperSize = 1
      LeftMargin = 10.000000000000000000
      RightMargin = 10.000000000000000000
      TopMargin = 10.000000000000000000
      BottomMargin = 10.000000000000000000
      object ReportTitle1: TfrxReportTitle
        Height = 64.252010000000000000
        Top = 18.897650000000000000
        Width = 740.409927000000000000
        object Memo1: TfrxMemoView
          Top = 11.338590000000000000
          Width = 423.307360000000000000
          Height = 37.795300000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlack
          Font.Height = -29
          Font.Name = 'Arial'
          Font.Style = []
          HAlign = haCenter
          Memo.UTF8 = (
            #1056#1115#1056#1111#1056#187#1056#176#1057#8218#1057#8249' '#1056#1111#1056#1109' '#1057#1027#1057#8225#1056#181#1057#8218#1056#176#1056#1112)
          ParentFont = False
        end
        object SysMemo1: TfrxSysMemoView
          Left = 642.520100000000000000
          Width = 94.488250000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            '[DATE]')
        end
        object Memo15: TfrxMemoView
          Left = 574.488560000000000000
          Width = 68.031540000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            #1056#1115#1057#8218#1057#8225#1056#181#1057#8218' '#1056#1109#1057#8218':')
        end
      end
      object MasterData1: TfrxMasterData
        Height = 37.795300000000000000
        Top = 207.874150000000000000
        Width = 740.409927000000000000
        DataSet = frxDBDataset1
        DataSetName = 'frxDBDataset1'
        RowCount = 0
        object Memo2: TfrxMemoView
          Left = 11.338590000000000000
          Top = 7.559059999999931000
          Width = 79.370130000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1053#1086#1084#1077#1088' '#1089#1095#1077#1090#1072
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#1116#1056#1109#1056#1112#1056#181#1057#1026' '#1057#1027#1057#8225#1056#181#1057#8218#1056#176'"]')
        end
        object Memo3: TfrxMemoView
          Left = 98.267780000000000000
          Top = 7.559059999999931000
          Width = 79.370130000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1057#1091#1084#1084#1072' '#1082' '#1086#1087#1083#1072#1090#1077
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#1038#1057#1107#1056#1112#1056#1112#1056#176' '#1056#1108' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1056#181'"]')
        end
        object Memo4: TfrxMemoView
          Left = 177.637910000000000000
          Top = 7.559059999999931000
          Width = 79.370130000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1057#1088#1086#1082' '#1086#1087#1083#1072#1090#1099
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#1038#1057#1026#1056#1109#1056#1108' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1057#8249'"]')
        end
        object Memo5: TfrxMemoView
          Left = 260.787570000000000000
          Top = 7.559059999999931000
          Width = 68.031540000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1054#1087#1083#1072#1095#1077#1085#1086
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#1115#1056#1111#1056#187#1056#176#1057#8225#1056#181#1056#1029#1056#1109'"]')
        end
        object Memo6: TfrxMemoView
          Left = 328.819110000000000000
          Top = 7.559059999999931000
          Width = 79.370130000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1044#1072#1090#1072' '#1086#1087#1083#1072#1090#1099
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#8221#1056#176#1057#8218#1056#176' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1057#8249'"]')
        end
        object Memo7: TfrxMemoView
          Left = 415.748300000000000000
          Top = 7.559059999999931000
          Width = 79.370130000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = #1053#1086#1084#1077#1088' '#1076#1086#1075#1086#1074#1086#1088#1072
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."'#1056#1116#1056#1109#1056#1112#1056#181#1057#1026' '#1056#1169#1056#1109#1056#1110#1056#1109#1056#1030#1056#1109#1057#1026#1056#176'"]')
        end
        object frxDBDataset1NAME: TfrxMemoView
          Left = 498.897960000000000000
          Top = 7.559059999999988000
          Width = 400.630180000000000000
          Height = 18.897650000000000000
          ShowHint = False
          DataField = 'NAME'
          DataSet = frxDBDataset1
          DataSetName = 'frxDBDataset1'
          Memo.UTF8 = (
            '[frxDBDataset1."NAME"]')
        end
      end
      object Header1: TfrxHeader
        Height = 41.574830000000000000
        Top = 143.622140000000000000
        Width = 740.409927000000000000
        object Memo8: TfrxMemoView
          Left = 7.559060000000000000
          Top = 3.779529999999994000
          Width = 94.488250000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1116#1056#1109#1056#1112#1056#181#1057#1026' '#1057#1027#1057#8225#1056#181#1057#8218#1056#176)
          ParentFont = False
        end
        object Memo9: TfrxMemoView
          Left = 98.267780000000000000
          Top = 3.779529999999994000
          Width = 71.811070000000000000
          Height = 34.015770000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1038#1057#1107#1056#1112#1056#1112#1056#176' '#1056#1108' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1056#181)
          ParentFont = False
        end
        object Memo10: TfrxMemoView
          Left = 177.637910000000000000
          Top = 3.779529999999994000
          Width = 83.149660000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1038#1057#1026#1056#1109#1056#1108' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1057#8249)
          ParentFont = False
        end
        object Memo11: TfrxMemoView
          Left = 260.787570000000000000
          Top = 3.779529999999994000
          Width = 68.031540000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1115#1056#1111#1056#187#1056#176#1057#8225#1056#181#1056#1029#1056#1109)
          ParentFont = False
        end
        object Memo12: TfrxMemoView
          Left = 328.819110000000000000
          Top = 3.779529999999994000
          Width = 86.929190000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#8221#1056#176#1057#8218#1056#176' '#1056#1109#1056#1111#1056#187#1056#176#1057#8218#1057#8249)
          ParentFont = False
        end
        object Memo13: TfrxMemoView
          Left = 415.748300000000000000
          Top = 3.779529999999994000
          Width = 83.149660000000000000
          Height = 37.795300000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1116#1056#1109#1056#1112#1056#181#1057#1026' '#1056#1169#1056#1109#1056#1110#1056#1109#1056#1030#1056#1109#1057#1026#1056#176)
          ParentFont = False
        end
        object Memo14: TfrxMemoView
          Left = 498.897960000000000000
          Top = 3.779529999999994000
          Width = 226.771800000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Font.Charset = DEFAULT_CHARSET
          Font.Color = clBlue
          Font.Height = -13
          Font.Name = 'Arial'
          Font.Style = [fsBold]
          Memo.UTF8 = (
            #1056#1119#1057#1026#1056#1105#1056#1029#1057#1039#1057#8218#1056#1109' '#1056#1109#1057#8218)
          ParentFont = False
        end
      end
      object PageFooter1: TfrxPageFooter
        Height = 37.795300000000000000
        Top = 306.141930000000000000
        Width = 740.409927000000000000
        object SysMemo2: TfrxSysMemoView
          Left = 374.173470000000000000
          Top = 3.779530000000022000
          Width = 18.897650000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            '[PAGE#]')
        end
        object Memo16: TfrxMemoView
          Left = 343.937230000000000000
          Top = 3.779530000000022000
          Width = 34.015770000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            #1056#1038#1057#8218#1057#1026'.')
        end
        object Memo17: TfrxMemoView
          Left = 385.512060000000000000
          Top = 3.779530000000022000
          Width = 18.897650000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            #1056#1105#1056#183)
        end
        object SysMemo3: TfrxSysMemoView
          Left = 404.409710000000000000
          Top = 3.779530000000022000
          Width = 94.488250000000000000
          Height = 18.897650000000000000
          ShowHint = False
          Memo.UTF8 = (
            '[TOTALPAGES#]')
        end
      end
    end
  end
  object frxDBDataset1: TfrxDBDataset
    UserName = 'frxDBDataset1'
    CloseDataSource = False
    DataSet = odsUnpayedBillsReport
    BCDToCurrency = False
    Top = 32
  end
  object odsUnpayedBillsReport: TOracleDataSet
    SQL.Strings = (
      
        'select b.bill_id as "'#1053#1086#1084#1077#1088' '#1089#1095#1077#1090#1072'", b.amount as "'#1057#1091#1084#1084#1072' '#1082' '#1086#1087#1083#1072#1090#1077'",' +
        ' to_char(b.expire_date, '#39'dd.mm.yyyy'#39') as "'#1057#1088#1086#1082' '#1086#1087#1083#1072#1090#1099'", '
      
        '       nvl(p.amount, 0) as "'#1054#1087#1083#1072#1095#1077#1085#1086'", p.pay_date as "'#1044#1072#1090#1072' '#1086#1087#1083#1072#1090 +
        #1099'", c.cntr_id as "'#1053#1086#1084#1077#1088' '#1076#1086#1075#1086#1074#1086#1088#1072'", ch.name'
      'from bills b left join payments p on b.bill_id = p.bill_bill_id'
      '             left join contracts c on b.cntr_cntr_id = c.cntr_id'
      
        '             left join client_histories ch on c.clnt_clnt_id = c' +
        'h.clnt_clnt_id'
      'where sysdate between ch.start_date and ch.end_date')
    ReadBuffer = 25
    Optimize = True
    Debug = False
    StringFieldsOnly = False
    SequenceField.ApplyMoment = amOnPost
    OracleDictionary.EnforceConstraints = False
    OracleDictionary.UseMessageTable = False
    OracleDictionary.DefaultValues = False
    OracleDictionary.DynamicDefaults = False
    OracleDictionary.FieldKinds = False
    OracleDictionary.DisplayFormats = False
    OracleDictionary.RangeValues = False
    OracleDictionary.RequiredFields = True
    QBEDefinition.SaveQBEValues = True
    QBEDefinition.AllowFileWildCards = True
    QBEDefinition.QBEFontColor = clNone
    QBEDefinition.QBEBackgroundColor = clNone
    QBEDefinition.QBEFieldDefs = {
      03000000070000000B000000CDEEECE5F020F1F7E5F2E001000000000E000000
      D1F3ECECE020EA20EEEFEBE0F2E501000000000B000000D1F0EEEA20EEEFEBE0
      F2FB010000000008000000CEEFEBE0F7E5EDEE01000000000B000000C4E0F2E0
      20EEEFEBE0F2FB01000000000E000000CDEEECE5F020E4EEE3EEE2EEF0E00100
      000000040000004E414D450100000000}
    Cursor = crDefault
    ReadOnly = False
    LockingMode = lmCheckImmediate
    QueryAllRecords = True
    CountAllRecords = False
    RefreshOptions = []
    CommitOnPost = True
    CachedUpdates = False
    QBEMode = False
    Session = fmMain.OracleSession
    DesignActivation = False
    Active = True
  end
  object MainMenu1: TMainMenu
    Left = 8
    Top = 120
    object N1: TMenuItem
      Caption = #1054#1090#1095#1077#1090
      object N2: TMenuItem
        Caption = #1055#1077#1095#1072#1090#1100
        OnClick = N2Click
      end
      object PDF1: TMenuItem
        Caption = #1069#1082#1089#1087#1086#1088#1090' '#1074' PDF'
        OnClick = PDF1Click
      end
      object N3: TMenuItem
        Caption = #1047#1072#1082#1088#1099#1090#1100
        OnClick = N3Click
      end
    end
  end
  object frxPDFExport1: TfrxPDFExport
    UseFileCache = True
    ShowProgress = True
    OverwritePrompt = False
    PrintOptimized = False
    Outline = False
    Background = False
    HTMLTags = True
    Author = 'FastReport'
    Subject = 'FastReport PDF export'
    ProtectionFlags = [ePrint, eModify, eCopy, eAnnot]
    HideToolbar = False
    HideMenubar = False
    HideWindowUI = False
    FitWindow = False
    CenterWindow = False
    PrintScaling = False
    Left = 8
    Top = 184
  end
end
